The Database API > Database API functions > MMDB.getSPParamsAsString() |
![]() ![]() ![]() |
Availability
Dreamweaver UltraDev 1.0
Description
Gets a comma-delimited string containing the list of parameters that the stored procedure takes.
Arguments
connName
, procName
![]() |
connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
![]() |
procName is the name of the stored procedure. |
Returns
A comma-delimited string containing the list of parameters that the stored procedure requires. The parameters' names, direction, and data type are included, separated by semicolons (;).
Example
The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast")
could return a string of form name startDate;direction:in;datatype:date, salary;direction:in;datatype:integer
Here, the stored procedure, getNewEmployeesMakingAtLeast
, has two parameters: startDate
and Salary
. For startDate
, the direction is in
and the data type is date
. For salary
, the direction is in
and the data type is date
.
![]() ![]() ![]() |